CREATE VIEW dbo.FACT_Sales AS
SELECT * 
FROM MyDataWarehouse.Data.FACT_Sales
UNION ALL
SELECT *
FROM SQL1.MyDataWarehouse.Data.FACT_Sales
UNION ALL
SELECT * 
FROM SQL2.MyDataWarehouse.Data.FACT_Sales
GO
